
阅片相关表
OrganInfo, 
ReadingQuestionCriterionSystem,
ReadingQuestionSystem,
ReadingTableQuestionSystem,
CriterionNidus,
ReadingCriterionDictionary,
ReadingMedicineSystemQuestion,
TumorAssessment

 注意  
CriterionNidus  和
ReadingCriterionDictionary  只用同步系统数据 IsSystemCriterion

可以  删除 在添加

delete CriterionNidus   where IsSystemCriterion=1

delete ReadingCriterionDictionary  where IsSystemCriterion=1



插入完成之后


delete CriterionNidus    where   (select count(1) as num from ReadingQuestionCriterionTrial where ReadingQuestionCriterionTrial.Id = CriterionNidus.CriterionId) = 0 and IsSystemCriterion=0
delete ReadingCriterionDictionary  where   (select count(1) as num from ReadingQuestionCriterionTrial where ReadingQuestionCriterionTrial.Id = ReadingCriterionDictionary.CriterionId) = 0 and IsSystemCriterion=0


